{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "aab701f9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5f1e682f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(\"广州_数据分析_实习生.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "5d676377",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>招聘</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>B轮</td>\n",
       "      <td>整车制造</td>\n",
       "      <td>超境汽车</td>\n",
       "      <td>['3个月', '提供转正', '本科', '数据分析', '数据建模', 'SQL']</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>实习</td>\n",
       "      <td>数据分析实习生</td>\n",
       "      <td>180-200元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>招聘经理/主管</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>其他</td>\n",
       "      <td>互联网</td>\n",
       "      <td>字节跳动</td>\n",
       "      <td>['4个月', '本科', '电商', '数据分析', '产品']</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>实习</td>\n",
       "      <td>国际化电商-数据分析实习生</td>\n",
       "      <td>200元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>营销专家</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>NaN</td>\n",
       "      <td>其他商务服务业</td>\n",
       "      <td>名创优品</td>\n",
       "      <td>['6个月', '提供转正', '本科', '市场调研分析', '数据分析', '市场营销'...</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>实习</td>\n",
       "      <td>市场策划实习生</td>\n",
       "      <td>150-180元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>数据分析师</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>北京易莱信科技有限公司</td>\n",
       "      <td>['本科', '数据分析', '数据清洗', '数据采集']</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>实习</td>\n",
       "      <td>数据分析师</td>\n",
       "      <td>130元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>运营总监</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>NaN</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>广州密航商业策划有限公司</td>\n",
       "      <td>['3个月', '提供转正', '学历不限', '新媒体运营', '社交平台', '平台运营...</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>实习</td>\n",
       "      <td>新媒体实习生</td>\n",
       "      <td>120-150元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>37</td>\n",
       "      <td>高级海外招聘专员</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>美股上市</td>\n",
       "      <td>互联网</td>\n",
       "      <td>广州市百果园网络科技有限公司</td>\n",
       "      <td>['本科', '电子商务', '商品类', '类目运营', '商品运营', '电商运营', ...</td>\n",
       "      <td>广州</td>\n",
       "      <td>实习</td>\n",
       "      <td>电商运营（波兰语）-intern</td>\n",
       "      <td>150元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>38</td>\n",
       "      <td>人力行政专员</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>专业技术服务</td>\n",
       "      <td>西美信息科技</td>\n",
       "      <td>['本科', '数据分析']</td>\n",
       "      <td>广州</td>\n",
       "      <td>实习</td>\n",
       "      <td>数据分析员</td>\n",
       "      <td>80元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>39</td>\n",
       "      <td>人事专员</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>广州市原象信息科技有限公司</td>\n",
       "      <td>['本科', '用户运营', '数据运营', '内容运营', '电子商务']</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>实习</td>\n",
       "      <td>内容电商运营实习生</td>\n",
       "      <td>100元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>0</td>\n",
       "      <td>行政专员</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>上海霖杰营销策划有限公司</td>\n",
       "      <td>['学历不限', '大数据']</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>实习</td>\n",
       "      <td>项目专员/助理</td>\n",
       "      <td>110元/天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>1</td>\n",
       "      <td>人力资源部经理</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>已上市</td>\n",
       "      <td>互联网</td>\n",
       "      <td>太平洋网络</td>\n",
       "      <td>['学历不限']</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>实习</td>\n",
       "      <td>汽车网-媒介实习生</td>\n",
       "      <td>120000元/月</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>162 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0 recruiter.recruiterTitle comp.compScale comp.compStage  \\\n",
       "0             0                       招聘       100-499人             B轮   \n",
       "1             1                  招聘经理/主管       10000人以上             其他   \n",
       "2             2                     营销专家       10000人以上            NaN   \n",
       "3             3                    数据分析师          1-49人          融资未公开   \n",
       "4             4                     运营总监          1-49人            NaN   \n",
       "..          ...                      ...            ...            ...   \n",
       "157          37                 高级海外招聘专员    5000-10000人           美股上市   \n",
       "158          38                   人力行政专员       100-499人          融资未公开   \n",
       "159          39                     人事专员       500-999人            NaN   \n",
       "160           0                     行政专员         50-99人            NaN   \n",
       "161           1                  人力资源部经理       500-999人            已上市   \n",
       "\n",
       "    comp.compIndustry   comp.compName  \\\n",
       "0                整车制造            超境汽车   \n",
       "1                 互联网            字节跳动   \n",
       "2             其他商务服务业            名创优品   \n",
       "3               计算机软件     北京易莱信科技有限公司   \n",
       "4               计算机软件    广州密航商业策划有限公司   \n",
       "..                ...             ...   \n",
       "157               互联网  广州市百果园网络科技有限公司   \n",
       "158            专业技术服务          西美信息科技   \n",
       "159          广告/公关/会展   广州市原象信息科技有限公司   \n",
       "160          广告/公关/会展    上海霖杰营销策划有限公司   \n",
       "161               互联网           太平洋网络   \n",
       "\n",
       "                                            job.labels  job.dq  \\\n",
       "0         ['3个月', '提供转正', '本科', '数据分析', '数据建模', 'SQL']  广州-海珠区   \n",
       "1                    ['4个月', '本科', '电商', '数据分析', '产品']  广州-海珠区   \n",
       "2    ['6个月', '提供转正', '本科', '市场调研分析', '数据分析', '市场营销'...  广州-海珠区   \n",
       "3                       ['本科', '数据分析', '数据清洗', '数据采集']  广州-越秀区   \n",
       "4    ['3个月', '提供转正', '学历不限', '新媒体运营', '社交平台', '平台运营...  广州-越秀区   \n",
       "..                                                 ...     ...   \n",
       "157  ['本科', '电子商务', '商品类', '类目运营', '商品运营', '电商运营', ...      广州   \n",
       "158                                     ['本科', '数据分析']      广州   \n",
       "159             ['本科', '用户运营', '数据运营', '内容运营', '电子商务']  广州-海珠区   \n",
       "160                                    ['学历不限', '大数据']  广州-越秀区   \n",
       "161                                           ['学历不限']  广州-天河区   \n",
       "\n",
       "    job.campusJobKind         job.title  job.salary  \n",
       "0                  实习           数据分析实习生  180-200元/天  \n",
       "1                  实习     国际化电商-数据分析实习生      200元/天  \n",
       "2                  实习           市场策划实习生  150-180元/天  \n",
       "3                  实习             数据分析师      130元/天  \n",
       "4                  实习            新媒体实习生  120-150元/天  \n",
       "..                ...               ...         ...  \n",
       "157                实习  电商运营（波兰语）-intern      150元/天  \n",
       "158                实习             数据分析员       80元/天  \n",
       "159                实习         内容电商运营实习生      100元/天  \n",
       "160                实习           项目专员/助理      110元/天  \n",
       "161                实习         汽车网-媒介实习生   120000元/月  \n",
       "\n",
       "[162 rows x 11 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3446af0c",
   "metadata": {},
   "source": [
    "# comp.compIndustry行业分析（Demo:单一分类数据词频分析）"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "91b95c42",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          整车制造\n",
       "1           互联网\n",
       "2       其他商务服务业\n",
       "3         计算机软件\n",
       "4         计算机软件\n",
       "         ...   \n",
       "157         互联网\n",
       "158      专业技术服务\n",
       "159    广告/公关/会展\n",
       "160    广告/公关/会展\n",
       "161         互联网\n",
       "Name: comp.compIndustry, Length: 162, dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['comp.compIndustry']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "f348009a",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "广州市百果园网络科技有限公司    8\n",
       "广州密航商业策划有限公司      4\n",
       "广州兴趣岛信息科技有限公司     4\n",
       "唯品会(中国)           3\n",
       "虎牙HUYA            3\n",
       "                 ..\n",
       "广东省红十字基金会         1\n",
       "广州欢聚时代信息科技有限公司    1\n",
       "粤港澳产融             1\n",
       "广州狄牛斯商贸有限公司       1\n",
       "太平洋网络             1\n",
       "Name: comp.compName, Length: 116, dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['comp.compName'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "28cf69c4",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('广州市百果园网络科技有限公司', 8),\n",
       " ('广州密航商业策划有限公司', 4),\n",
       " ('广州兴趣岛信息科技有限公司', 4),\n",
       " ('唯品会(中国)', 3),\n",
       " ('虎牙HUYA', 3),\n",
       " ('字节跳动', 3),\n",
       " ('高德置地控股有限公司', 3),\n",
       " ('广州美太', 3),\n",
       " ('上海寻梦信息技术有限公司', 3),\n",
       " ('上海言某信息科技有限公司', 3),\n",
       " ('即能科技(广州)有限公司', 3),\n",
       " ('广州市原象信息科技有限公司', 2),\n",
       " ('西美信息科技', 2),\n",
       " ('细刻科技', 2),\n",
       " ('广东省大湾区集成电路与系统应用研究院', 2),\n",
       " ('广州万孚', 2),\n",
       " ('卓动科技', 2),\n",
       " ('广州山水比德设计股份有限公司', 2),\n",
       " ('合景悠活控股集团', 2),\n",
       " ('韦莱韬悦', 2),\n",
       " ('卓越教育集团', 2),\n",
       " ('新漾科技', 2),\n",
       " ('越秀地产IT共享中心', 2),\n",
       " ('思派健康', 2),\n",
       " ('福思特科技', 2),\n",
       " ('北京清能互联科技有限公司', 2),\n",
       " ('诚伯', 2),\n",
       " ('名创优品', 2),\n",
       " ('广州功夫新媒体网络科技有限公司', 1),\n",
       " ('广州玻思韬控释药业有限公司', 1),\n",
       " ('广州乐牛游戏', 1),\n",
       " ('上海霖杰营销策划有限公司', 1),\n",
       " ('奥飞娱乐', 1),\n",
       " ('广东商阅数字传媒有限公司', 1),\n",
       " ('广东海灏湾发展有限公司', 1),\n",
       " ('JLL 仲量联行', 1),\n",
       " ('广州市迪垭国际贸易有限公司', 1),\n",
       " ('雨花石云计算', 1),\n",
       " ('广州中汇成信息科技有限公司', 1),\n",
       " ('广发证券', 1),\n",
       " ('常相伴(武汉)科技有限公司', 1),\n",
       " ('赣州柯文时尚服饰有限公司广州分公司', 1),\n",
       " ('中智管理咨询有限公司', 1),\n",
       " ('国海证券', 1),\n",
       " ('辰元资管', 1),\n",
       " ('保利物业服务股份有限公司', 1),\n",
       " ('赛诺菲', 1),\n",
       " ('广州银行信用卡', 1),\n",
       " ('捷碳(上海)科技有限公司', 1),\n",
       " ('大圣科技股份有限公司', 1),\n",
       " ('广州城投智奥发展有限公司', 1),\n",
       " ('广州科铄软件科技有限公司', 1),\n",
       " ('佛山市观迪医疗器械有限公司', 1),\n",
       " ('北京虎示传媒有限公司', 1),\n",
       " ('标榜汽车用品', 1),\n",
       " ('灵感互娱', 1),\n",
       " ('广州方舟市场研究咨询有限公司', 1),\n",
       " ('维达商贸有限公司', 1),\n",
       " ('飞动文化', 1),\n",
       " ('葆元生物医药科技(杭州)有限公司', 1),\n",
       " ('平安银行股份有限公司汽车消费金融中心', 1),\n",
       " ('赞同科技股份有限公司', 1),\n",
       " ('广州市城市更新规划研究院', 1),\n",
       " ('上海复洁环保', 1),\n",
       " ('为心爱', 1),\n",
       " ('广州市格米网络科技有限公司', 1),\n",
       " ('广州优盟网络信息有限公司', 1),\n",
       " ('广州地铁设计研究院股份有限公司', 1),\n",
       " ('税季咨询(广州)有限公司', 1),\n",
       " ('超境汽车', 1),\n",
       " ('大旗财税', 1),\n",
       " ('舒信咨询', 1),\n",
       " ('环亚化妆品（滋源/美肤宝/法兰琳卡）', 1),\n",
       " ('汤臣倍健药业有限公司', 1),\n",
       " ('广州顶鎏信息科技有限公司', 1),\n",
       " ('广州筑绿环保建材有限公司', 1),\n",
       " ('汤臣倍健', 1),\n",
       " ('粤规院', 1),\n",
       " ('米波智联(MEEPO)', 1),\n",
       " ('广州梦映动漫网络科技有限公司', 1),\n",
       " ('优合(广州)商贸有限公司', 1),\n",
       " ('广州云智达创科技有限公司', 1),\n",
       " ('阿科玛', 1),\n",
       " ('广州悟空醉科技有限公司', 1),\n",
       " ('广州叁伍陆科技有限公司', 1),\n",
       " ('亿牛', 1),\n",
       " ('巨湾技研', 1),\n",
       " ('广东省广新控股集团有限公司', 1),\n",
       " ('PerfectDiary完美日记', 1),\n",
       " ('中都物流有限公司', 1),\n",
       " ('广州泰加昇贸易有限公司', 1),\n",
       " ('北京易莱信科技有限公司', 1),\n",
       " ('广州阿尔法医疗科技有限公司', 1),\n",
       " ('佛山市精一家具有限公司', 1),\n",
       " ('中望软件', 1),\n",
       " ('探迹科技', 1),\n",
       " ('数业智能', 1),\n",
       " ('上海艾瑞市场咨询股份有限公司', 1),\n",
       " ('德塔幂方', 1),\n",
       " ('广州毅腾技术服务有限责任公司', 1),\n",
       " ('视源股份', 1),\n",
       " ('广州简家家居用品有限公司', 1),\n",
       " ('北京互联企信信息技术有限公司', 1),\n",
       " ('盈米基金', 1),\n",
       " ('小鹏汽车', 1),\n",
       " ('海南信保风神建设管理有限公司', 1),\n",
       " ('广州星河湾物业管理服务有限公司南村分公司', 1),\n",
       " ('柏丽德珠宝(广州)有限公司', 1),\n",
       " ('鼎实-复利资产配置', 1),\n",
       " ('广州视琨电子科技有限公司', 1),\n",
       " ('广州香雪国际公寓', 1),\n",
       " ('广东省红十字基金会', 1),\n",
       " ('广州欢聚时代信息科技有限公司', 1),\n",
       " ('粤港澳产融', 1),\n",
       " ('广州狄牛斯商贸有限公司', 1),\n",
       " ('太平洋网络', 1)]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "word_compName = [(i,v) for i,v in df['comp.compName'].value_counts().items()]\n",
    "word_compName"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "cb94c01c",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/v5/echarts.min', 'echarts-wordcloud':'https://assets.pyecharts.org/assets/v5/echarts-wordcloud.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "        <div id=\"aa88aabc4f7843bb9eb2a78d2941ca20\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "<script>\n",
       "        require(['echarts', 'echarts-wordcloud'], function(echarts) {\n",
       "                var chart_aa88aabc4f7843bb9eb2a78d2941ca20 = echarts.init(\n",
       "                    document.getElementById('aa88aabc4f7843bb9eb2a78d2941ca20'), 'white', {renderer: 'canvas'});\n",
       "                var option_aa88aabc4f7843bb9eb2a78d2941ca20 = {\n",
       "    \"animation\": true,\n",
       "    \"animationThreshold\": 2000,\n",
       "    \"animationDuration\": 1000,\n",
       "    \"animationEasing\": \"cubicOut\",\n",
       "    \"animationDelay\": 0,\n",
       "    \"animationDurationUpdate\": 300,\n",
       "    \"animationEasingUpdate\": \"cubicOut\",\n",
       "    \"animationDelayUpdate\": 0,\n",
       "    \"aria\": {\n",
       "        \"enabled\": false\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#5470c6\",\n",
       "        \"#91cc75\",\n",
       "        \"#fac858\",\n",
       "        \"#ee6666\",\n",
       "        \"#73c0de\",\n",
       "        \"#3ba272\",\n",
       "        \"#fc8452\",\n",
       "        \"#9a60b4\",\n",
       "        \"#ea7ccc\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"wordCloud\",\n",
       "            \"name\": \"\\u70ed\\u70b9\\u5206\\u6790\",\n",
       "            \"shape\": \"circle\",\n",
       "            \"rotationRange\": [\n",
       "                -90,\n",
       "                90\n",
       "            ],\n",
       "            \"rotationStep\": 45,\n",
       "            \"girdSize\": 20,\n",
       "            \"sizeRange\": [\n",
       "                6,\n",
       "                66\n",
       "            ],\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5e02\\u767e\\u679c\\u56ed\\u7f51\\u7edc\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 8,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(106,50,74)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5bc6\\u822a\\u5546\\u4e1a\\u7b56\\u5212\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 4,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(97,11,135)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5174\\u8da3\\u5c9b\\u4fe1\\u606f\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 4,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(160,138,12)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u552f\\u54c1\\u4f1a(\\u4e2d\\u56fd)\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(45,1,97)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u864e\\u7259HUYA\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(62,130,5)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(145,59,121)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9ad8\\u5fb7\\u7f6e\\u5730\\u63a7\\u80a1\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(70,4,66)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u7f8e\\u592a\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(16,141,42)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\\u5bfb\\u68a6\\u4fe1\\u606f\\u6280\\u672f\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(104,73,119)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\\u8a00\\u67d0\\u4fe1\\u606f\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(37,37,5)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5373\\u80fd\\u79d1\\u6280(\\u5e7f\\u5dde)\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 3,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(125,78,97)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5e02\\u539f\\u8c61\\u4fe1\\u606f\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(0,7,90)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u897f\\u7f8e\\u4fe1\\u606f\\u79d1\\u6280\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(107,155,146)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7ec6\\u523b\\u79d1\\u6280\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(148,81,76)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u4e1c\\u7701\\u5927\\u6e7e\\u533a\\u96c6\\u6210\\u7535\\u8def\\u4e0e\\u7cfb\\u7edf\\u5e94\\u7528\\u7814\\u7a76\\u9662\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(63,157,13)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u4e07\\u5b5a\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(85,14,39)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5353\\u52a8\\u79d1\\u6280\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(76,86,7)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5c71\\u6c34\\u6bd4\\u5fb7\\u8bbe\\u8ba1\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(47,1,78)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5408\\u666f\\u60a0\\u6d3b\\u63a7\\u80a1\\u96c6\\u56e2\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(31,82,112)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u97e6\\u83b1\\u97ec\\u60a6\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(45,54,3)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5353\\u8d8a\\u6559\\u80b2\\u96c6\\u56e2\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(92,26,51)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u65b0\\u6f3e\\u79d1\\u6280\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(32,27,158)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8d8a\\u79c0\\u5730\\u4ea7IT\\u5171\\u4eab\\u4e2d\\u5fc3\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(135,141,102)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u601d\\u6d3e\\u5065\\u5eb7\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(63,148,32)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u798f\\u601d\\u7279\\u79d1\\u6280\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(100,28,128)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\\u6e05\\u80fd\\u4e92\\u8054\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(94,36,136)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8bda\\u4f2f\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(152,125,16)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u540d\\u521b\\u4f18\\u54c1\",\n",
       "                    \"value\": 2,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(46,26,122)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u529f\\u592b\\u65b0\\u5a92\\u4f53\\u7f51\\u7edc\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(123,42,122)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u73bb\\u601d\\u97ec\\u63a7\\u91ca\\u836f\\u4e1a\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(134,38,86)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u4e50\\u725b\\u6e38\\u620f\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(117,154,108)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\\u9716\\u6770\\u8425\\u9500\\u7b56\\u5212\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(118,97,6)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5965\\u98de\\u5a31\\u4e50\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(22,24,11)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u4e1c\\u5546\\u9605\\u6570\\u5b57\\u4f20\\u5a92\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(80,124,26)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u4e1c\\u6d77\\u704f\\u6e7e\\u53d1\\u5c55\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(52,105,141)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"JLL \\u4ef2\\u91cf\\u8054\\u884c\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(57,114,147)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5e02\\u8fea\\u57ad\\u56fd\\u9645\\u8d38\\u6613\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(42,99,105)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u96e8\\u82b1\\u77f3\\u4e91\\u8ba1\\u7b97\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(5,85,96)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u4e2d\\u6c47\\u6210\\u4fe1\\u606f\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(115,91,65)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u53d1\\u8bc1\\u5238\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(143,16,19)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e38\\u76f8\\u4f34(\\u6b66\\u6c49)\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(122,150,76)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8d63\\u5dde\\u67ef\\u6587\\u65f6\\u5c1a\\u670d\\u9970\\u6709\\u9650\\u516c\\u53f8\\u5e7f\\u5dde\\u5206\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(95,35,122)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e2d\\u667a\\u7ba1\\u7406\\u54a8\\u8be2\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(84,45,92)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u56fd\\u6d77\\u8bc1\\u5238\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(98,48,91)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8fb0\\u5143\\u8d44\\u7ba1\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(160,28,107)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4fdd\\u5229\\u7269\\u4e1a\\u670d\\u52a1\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(42,26,57)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8d5b\\u8bfa\\u83f2\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(90,11,55)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u94f6\\u884c\\u4fe1\\u7528\\u5361\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(1,53,60)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6377\\u78b3(\\u4e0a\\u6d77)\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(158,96,139)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5927\\u5723\\u79d1\\u6280\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(12,14,96)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u57ce\\u6295\\u667a\\u5965\\u53d1\\u5c55\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(101,97,34)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u79d1\\u94c4\\u8f6f\\u4ef6\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(130,23,12)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4f5b\\u5c71\\u5e02\\u89c2\\u8fea\\u533b\\u7597\\u5668\\u68b0\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(143,55,14)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\\u864e\\u793a\\u4f20\\u5a92\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(101,48,133)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6807\\u699c\\u6c7d\\u8f66\\u7528\\u54c1\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(26,64,21)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7075\\u611f\\u4e92\\u5a31\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(87,37,21)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u65b9\\u821f\\u5e02\\u573a\\u7814\\u7a76\\u54a8\\u8be2\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(84,38,154)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7ef4\\u8fbe\\u5546\\u8d38\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(14,153,33)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u98de\\u52a8\\u6587\\u5316\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(13,44,4)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8446\\u5143\\u751f\\u7269\\u533b\\u836f\\u79d1\\u6280(\\u676d\\u5dde)\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(105,13,0)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e73\\u5b89\\u94f6\\u884c\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\\u6c7d\\u8f66\\u6d88\\u8d39\\u91d1\\u878d\\u4e2d\\u5fc3\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(120,140,150)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8d5e\\u540c\\u79d1\\u6280\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(148,153,25)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5e02\\u57ce\\u5e02\\u66f4\\u65b0\\u89c4\\u5212\\u7814\\u7a76\\u9662\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(142,17,105)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\\u590d\\u6d01\\u73af\\u4fdd\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(128,88,10)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e3a\\u5fc3\\u7231\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(157,33,60)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5e02\\u683c\\u7c73\\u7f51\\u7edc\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(14,51,159)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u4f18\\u76df\\u7f51\\u7edc\\u4fe1\\u606f\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(58,103,41)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u5730\\u94c1\\u8bbe\\u8ba1\\u7814\\u7a76\\u9662\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(33,137,34)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7a0e\\u5b63\\u54a8\\u8be2(\\u5e7f\\u5dde)\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(62,15,105)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8d85\\u5883\\u6c7d\\u8f66\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(32,27,26)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5927\\u65d7\\u8d22\\u7a0e\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(85,43,91)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8212\\u4fe1\\u54a8\\u8be2\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(76,29,17)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u73af\\u4e9a\\u5316\\u5986\\u54c1\\uff08\\u6ecb\\u6e90/\\u7f8e\\u80a4\\u5b9d/\\u6cd5\\u5170\\u7433\\u5361\\uff09\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(112,5,41)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6c64\\u81e3\\u500d\\u5065\\u836f\\u4e1a\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(93,25,41)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u9876\\u938f\\u4fe1\\u606f\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(2,137,66)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u7b51\\u7eff\\u73af\\u4fdd\\u5efa\\u6750\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(53,4,13)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6c64\\u81e3\\u500d\\u5065\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(19,65,1)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7ca4\\u89c4\\u9662\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(4,156,70)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7c73\\u6ce2\\u667a\\u8054(MEEPO)\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(95,136,112)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u68a6\\u6620\\u52a8\\u6f2b\\u7f51\\u7edc\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(157,38,82)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4f18\\u5408(\\u5e7f\\u5dde)\\u5546\\u8d38\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(36,86,99)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u4e91\\u667a\\u8fbe\\u521b\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(52,18,112)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u963f\\u79d1\\u739b\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(159,119,45)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u609f\\u7a7a\\u9189\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(86,40,155)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u53c1\\u4f0d\\u9646\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(84,52,13)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4ebf\\u725b\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(151,27,23)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5de8\\u6e7e\\u6280\\u7814\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(3,115,29)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u4e1c\\u7701\\u5e7f\\u65b0\\u63a7\\u80a1\\u96c6\\u56e2\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(7,98,12)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"PerfectDiary\\u5b8c\\u7f8e\\u65e5\\u8bb0\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(147,27,65)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e2d\\u90fd\\u7269\\u6d41\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(9,54,63)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u6cf0\\u52a0\\u6607\\u8d38\\u6613\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(142,78,114)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\\u6613\\u83b1\\u4fe1\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(28,46,98)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u963f\\u5c14\\u6cd5\\u533b\\u7597\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(63,6,41)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4f5b\\u5c71\\u5e02\\u7cbe\\u4e00\\u5bb6\\u5177\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(63,137,122)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e2d\\u671b\\u8f6f\\u4ef6\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(1,65,133)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u63a2\\u8ff9\\u79d1\\u6280\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(65,89,154)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6570\\u4e1a\\u667a\\u80fd\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(160,82,109)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\\u827e\\u745e\\u5e02\\u573a\\u54a8\\u8be2\\u80a1\\u4efd\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(90,119,125)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5fb7\\u5854\\u5e42\\u65b9\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(87,103,158)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u6bc5\\u817e\\u6280\\u672f\\u670d\\u52a1\\u6709\\u9650\\u8d23\\u4efb\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(124,153,143)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u89c6\\u6e90\\u80a1\\u4efd\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(160,101,31)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u7b80\\u5bb6\\u5bb6\\u5c45\\u7528\\u54c1\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(74,125,19)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\\u4e92\\u8054\\u4f01\\u4fe1\\u4fe1\\u606f\\u6280\\u672f\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(40,45,31)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u76c8\\u7c73\\u57fa\\u91d1\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(146,40,106)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5c0f\\u9e4f\\u6c7d\\u8f66\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(13,106,110)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6d77\\u5357\\u4fe1\\u4fdd\\u98ce\\u795e\\u5efa\\u8bbe\\u7ba1\\u7406\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(55,151,126)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u661f\\u6cb3\\u6e7e\\u7269\\u4e1a\\u7ba1\\u7406\\u670d\\u52a1\\u6709\\u9650\\u516c\\u53f8\\u5357\\u6751\\u5206\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(119,86,72)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u67cf\\u4e3d\\u5fb7\\u73e0\\u5b9d(\\u5e7f\\u5dde)\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(78,99,51)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9f0e\\u5b9e-\\u590d\\u5229\\u8d44\\u4ea7\\u914d\\u7f6e\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(56,152,149)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u89c6\\u7428\\u7535\\u5b50\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(49,56,14)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u9999\\u96ea\\u56fd\\u9645\\u516c\\u5bd3\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(4,13,102)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u4e1c\\u7701\\u7ea2\\u5341\\u5b57\\u57fa\\u91d1\\u4f1a\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(119,92,147)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u6b22\\u805a\\u65f6\\u4ee3\\u4fe1\\u606f\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(72,25,15)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7ca4\\u6e2f\\u6fb3\\u4ea7\\u878d\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(11,19,24)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\\u72c4\\u725b\\u65af\\u5546\\u8d38\\u6709\\u9650\\u516c\\u53f8\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(50,36,46)\"\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u592a\\u5e73\\u6d0b\\u7f51\\u7edc\",\n",
       "                    \"value\": 1,\n",
       "                    \"textStyle\": {\n",
       "                        \"color\": \"rgb(104,117,20)\"\n",
       "                    }\n",
       "                }\n",
       "            ],\n",
       "            \"drawOutOfBound\": false,\n",
       "            \"textStyle\": {\n",
       "                \"emphasis\": {}\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [],\n",
       "            \"selected\": {},\n",
       "            \"show\": true,\n",
       "            \"padding\": 5,\n",
       "            \"itemGap\": 10,\n",
       "            \"itemWidth\": 25,\n",
       "            \"itemHeight\": 14,\n",
       "            \"backgroundColor\": \"transparent\",\n",
       "            \"borderColor\": \"#ccc\",\n",
       "            \"borderWidth\": 1,\n",
       "            \"borderRadius\": 0,\n",
       "            \"pageButtonItemGap\": 5,\n",
       "            \"pageButtonPosition\": \"end\",\n",
       "            \"pageFormatter\": \"{current}/{total}\",\n",
       "            \"pageIconColor\": \"#2f4554\",\n",
       "            \"pageIconInactiveColor\": \"#aaa\",\n",
       "            \"pageIconSize\": 15,\n",
       "            \"animationDurationUpdate\": 800,\n",
       "            \"selector\": false,\n",
       "            \"selectorPosition\": \"auto\",\n",
       "            \"selectorItemGap\": 7,\n",
       "            \"selectorButtonGap\": 10\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"showContent\": true,\n",
       "        \"alwaysShowContent\": false,\n",
       "        \"showDelay\": 0,\n",
       "        \"hideDelay\": 100,\n",
       "        \"enterable\": false,\n",
       "        \"confine\": false,\n",
       "        \"appendToBody\": false,\n",
       "        \"transitionDuration\": 0.4,\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"padding\": 5,\n",
       "        \"order\": \"seriesAsc\"\n",
       "    },\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"text\": \"\\u70ed\\u70b9\\u5206\\u6790\",\n",
       "            \"target\": \"blank\",\n",
       "            \"subtarget\": \"blank\",\n",
       "            \"padding\": 5,\n",
       "            \"itemGap\": 10,\n",
       "            \"textAlign\": \"auto\",\n",
       "            \"textVerticalAlign\": \"auto\",\n",
       "            \"triggerEvent\": false,\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 23\n",
       "            }\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "                chart_aa88aabc4f7843bb9eb2a78d2941ca20.setOption(option_aa88aabc4f7843bb9eb2a78d2941ca20);\n",
       "        });\n",
       "    </script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x204d54897c0>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import json\n",
    "\n",
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import WordCloud\n",
    "\n",
    "c = (\n",
    "    WordCloud()\n",
    "    .add(series_name=\"热点分析\", data_pair=word_compName, word_size_range=[6, 66])\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(\n",
    "            title=\"热点分析\", title_textstyle_opts=opts.TextStyleOpts(font_size=23)\n",
    "        ),\n",
    "        tooltip_opts=opts.TooltipOpts(is_show=True),\n",
    "    ) \n",
    ")\n",
    "c.render_notebook()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "132440f7",
   "metadata": {},
   "source": [
    "# 多层级的字段分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "dda05dee",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'recruiter.recruiterTitle', 'comp.compScale',\n",
       "       'comp.compStage', 'comp.compIndustry', 'comp.compName', 'job.labels',\n",
       "       'job.dq', 'job.campusJobKind', 'job.title', 'job.salary'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "9e7dbc35",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compStage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>超境汽车</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>B轮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>字节跳动</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>其他</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>名创优品</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>北京易莱信科技有限公司</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>融资未公开</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>广州密航商业策划有限公司</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>广州市百果园网络科技有限公司</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>美股上市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>西美信息科技</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>融资未公开</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>广州市原象信息科技有限公司</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>上海霖杰营销策划有限公司</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>太平洋网络</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>已上市</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>162 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      comp.compName comp.compScale comp.compStage\n",
       "0              超境汽车       100-499人             B轮\n",
       "1              字节跳动       10000人以上             其他\n",
       "2              名创优品       10000人以上            NaN\n",
       "3       北京易莱信科技有限公司          1-49人          融资未公开\n",
       "4      广州密航商业策划有限公司          1-49人            NaN\n",
       "..              ...            ...            ...\n",
       "157  广州市百果园网络科技有限公司    5000-10000人           美股上市\n",
       "158          西美信息科技       100-499人          融资未公开\n",
       "159   广州市原象信息科技有限公司       500-999人            NaN\n",
       "160    上海霖杰营销策划有限公司         50-99人            NaN\n",
       "161           太平洋网络       500-999人            已上市\n",
       "\n",
       "[162 rows x 3 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['comp.compName','comp.compScale','comp.compStage']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c66e95d9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "广州-黄埔区\n",
      "广州-番禺区\n",
      "广州-天河区\n",
      "广州-增城区\n",
      "广州-海珠区\n",
      "广州-南沙区\n",
      "广州-越秀区\n",
      "广州\n"
     ]
    }
   ],
   "source": [
    "for i in set(df['job.dq']):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "8c9a1cdb",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "字节跳动\n",
      "广东省大湾区集成电路与系统应用研究院\n",
      "葆元生物医药科技(杭州)有限公司\n",
      "广州山水比德设计股份有限公司\n",
      "广州云智达创科技有限公司\n",
      "上海言某信息科技有限公司\n",
      "飞动文化\n",
      "广州乐牛游戏\n",
      "上海霖杰营销策划有限公司\n",
      "诚伯\n",
      "PerfectDiary完美日记\n",
      "合景悠活控股集团\n",
      "常相伴(武汉)科技有限公司\n",
      "数业智能\n",
      "广州优盟网络信息有限公司\n",
      "广州毅腾技术服务有限责任公司\n",
      "标榜汽车用品\n",
      "广州简家家居用品有限公司\n",
      "广州方舟市场研究咨询有限公司\n",
      "广州视琨电子科技有限公司\n",
      "佛山市精一家具有限公司\n",
      "探迹科技\n",
      "广州万孚\n",
      "柏丽德珠宝(广州)有限公司\n",
      "海南信保风神建设管理有限公司\n",
      "JLL 仲量联行\n",
      "上海艾瑞市场咨询股份有限公司\n",
      "巨湾技研\n",
      "亿牛\n",
      "广州市原象信息科技有限公司\n",
      "赞同科技股份有限公司\n",
      "细刻科技\n",
      "广州密航商业策划有限公司\n",
      "广州泰加昇贸易有限公司\n",
      "广州地铁设计研究院股份有限公司\n",
      "广州悟空醉科技有限公司\n",
      "广州筑绿环保建材有限公司\n",
      "税季咨询(广州)有限公司\n",
      "广东商阅数字传媒有限公司\n",
      "盈米基金\n",
      "上海寻梦信息技术有限公司\n",
      "大旗财税\n",
      "阿科玛\n",
      "粤港澳产融\n",
      "卓动科技\n",
      "广州阿尔法医疗科技有限公司\n",
      "高德置地控股有限公司\n",
      "广州玻思韬控释药业有限公司\n",
      "北京互联企信信息技术有限公司\n",
      "保利物业服务股份有限公司\n",
      "中都物流有限公司\n",
      "福思特科技\n",
      "广州银行信用卡\n",
      "佛山市观迪医疗器械有限公司\n",
      "名创优品\n",
      "越秀地产IT共享中心\n",
      "北京虎示传媒有限公司\n",
      "虎牙HUYA\n",
      "广州兴趣岛信息科技有限公司\n",
      "唯品会(中国)\n",
      "汤臣倍健\n",
      "新漾科技\n",
      "赣州柯文时尚服饰有限公司广州分公司\n",
      "德塔幂方\n",
      "中望软件\n",
      "广州欢聚时代信息科技有限公司\n",
      "汤臣倍健药业有限公司\n",
      "广州香雪国际公寓\n",
      "广州叁伍陆科技有限公司\n",
      "广州市百果园网络科技有限公司\n",
      "粤规院\n",
      "视源股份\n",
      "广发证券\n",
      "北京易莱信科技有限公司\n",
      "舒信咨询\n",
      "广州中汇成信息科技有限公司\n",
      "韦莱韬悦\n",
      "广州梦映动漫网络科技有限公司\n",
      "为心爱\n",
      "广州市格米网络科技有限公司\n",
      "鼎实-复利资产配置\n",
      "即能科技(广州)有限公司\n",
      "广州城投智奥发展有限公司\n",
      "广州狄牛斯商贸有限公司\n",
      "大圣科技股份有限公司\n",
      "平安银行股份有限公司汽车消费金融中心\n",
      "广东省红十字基金会\n",
      "辰元资管\n",
      "思派健康\n",
      "广州市城市更新规划研究院\n",
      "广州科铄软件科技有限公司\n",
      "灵感互娱\n",
      "捷碳(上海)科技有限公司\n",
      "北京清能互联科技有限公司\n",
      "卓越教育集团\n",
      "雨花石云计算\n",
      "奥飞娱乐\n",
      "广州功夫新媒体网络科技有限公司\n",
      "广州市迪垭国际贸易有限公司\n",
      "超境汽车\n",
      "广州顶鎏信息科技有限公司\n",
      "广东省广新控股集团有限公司\n",
      "西美信息科技\n",
      "米波智联(MEEPO)\n",
      "环亚化妆品（滋源/美肤宝/法兰琳卡）\n",
      "中智管理咨询有限公司\n",
      "小鹏汽车\n",
      "广州美太\n",
      "广州星河湾物业管理服务有限公司南村分公司\n",
      "广东海灏湾发展有限公司\n",
      "赛诺菲\n",
      "上海复洁环保\n",
      "太平洋网络\n",
      "维达商贸有限公司\n",
      "优合(广州)商贸有限公司\n",
      "国海证券\n"
     ]
    }
   ],
   "source": [
    "for j in set(df['comp.compName']):\n",
    "    print(j)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "0546b31d",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'IT服务',\n",
       " nan,\n",
       " '专业技术服务',\n",
       " '云计算/大数据',\n",
       " '互联网',\n",
       " '人力资源服务',\n",
       " '制药',\n",
       " '在线教育',\n",
       " '基金/证券/期货',\n",
       " '房地产开发经营',\n",
       " '批发/零售',\n",
       " '整车制造',\n",
       " '游戏',\n",
       " '环保',\n",
       " '电子商务',\n",
       " '科技金融',\n",
       " '计算机软件',\n",
       " '贸易/进出口',\n",
       " '通信设备',\n",
       " '银行',\n",
       " '非营利组织'}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州天河区产业集合 = set(df[df['job.dq'].isin(['广州-天河区'])]['comp.compIndustry'])\n",
    "广州天河区产业集合"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "ae159112",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name '广州' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "Input \u001b[1;32mIn [30]\u001b[0m, in \u001b[0;36m<cell line: 1>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[0m 广州天河行业_岗位 \u001b[38;5;241m=\u001b[39m {\n\u001b[0;32m      2\u001b[0m     i:广州\u001b[38;5;241m-\u001b[39m天河区[广州\u001b[38;5;241m-\u001b[39m天河区[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mcomp.compIndustry\u001b[39m\u001b[38;5;124m'\u001b[39m]\u001b[38;5;241m.\u001b[39misin([i])][\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mjob.title\u001b[39m\u001b[38;5;124m'\u001b[39m]\u001b[38;5;241m.\u001b[39mvalues\u001b[38;5;241m.\u001b[39mtolist()\n\u001b[0;32m      3\u001b[0m     \u001b[38;5;28;01mfor\u001b[39;00m i \u001b[38;5;129;01min\u001b[39;00m 广州天河区产业集合\n\u001b[0;32m      4\u001b[0m }\n\u001b[0;32m      5\u001b[0m 广州天河行业_岗位\n",
      "Input \u001b[1;32mIn [30]\u001b[0m, in \u001b[0;36m<dictcomp>\u001b[1;34m(.0)\u001b[0m\n\u001b[0;32m      1\u001b[0m 广州天河行业_岗位 \u001b[38;5;241m=\u001b[39m {\n\u001b[1;32m----> 2\u001b[0m     i:\u001b[43m广州\u001b[49m\u001b[38;5;241m-\u001b[39m天河区[广州\u001b[38;5;241m-\u001b[39m天河区[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mcomp.compIndustry\u001b[39m\u001b[38;5;124m'\u001b[39m]\u001b[38;5;241m.\u001b[39misin([i])][\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mjob.title\u001b[39m\u001b[38;5;124m'\u001b[39m]\u001b[38;5;241m.\u001b[39mvalues\u001b[38;5;241m.\u001b[39mtolist()\n\u001b[0;32m      3\u001b[0m     \u001b[38;5;28;01mfor\u001b[39;00m i \u001b[38;5;129;01min\u001b[39;00m 广州天河区产业集合\n\u001b[0;32m      4\u001b[0m }\n\u001b[0;32m      5\u001b[0m 广州天河行业_岗位\n",
      "\u001b[1;31mNameError\u001b[0m: name '广州' is not defined"
     ]
    }
   ],
   "source": [
    "广州天河行业_岗位 = {\n",
    "    i:广州-天河区[广州-天河区['comp.compIndustry'].isin([i])]['job.title'].values.tolist()\n",
    "    for i in 广州天河区产业集合\n",
    "}\n",
    "广州天河行业_岗位"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "840f1e80",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name '广州天河行业_岗位' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "Input \u001b[1;32mIn [31]\u001b[0m, in \u001b[0;36m<cell line: 3>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      1\u001b[0m data \u001b[38;5;241m=\u001b[39m [\n\u001b[0;32m      2\u001b[0m     {\n\u001b[0;32m      3\u001b[0m         \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mname\u001b[39m\u001b[38;5;124m\"\u001b[39m:\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124m广州-天河区\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[1;32m----> 4\u001b[0m         \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mchildren\u001b[39m\u001b[38;5;124m\"\u001b[39m:[\n\u001b[0;32m      5\u001b[0m             {\n\u001b[0;32m      6\u001b[0m             \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mname\u001b[39m\u001b[38;5;124m'\u001b[39m:i,\n\u001b[0;32m      7\u001b[0m             \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mchildren\u001b[39m\u001b[38;5;124m'\u001b[39m:[\n\u001b[0;32m      8\u001b[0m                 {\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mname\u001b[39m\u001b[38;5;124m'\u001b[39m:j} \u001b[38;5;28;01mfor\u001b[39;00m j \u001b[38;5;129;01min\u001b[39;00m 广州天河行业_岗位[i]]\n\u001b[0;32m      9\u001b[0m             } \n\u001b[0;32m     10\u001b[0m             \u001b[38;5;28;01mfor\u001b[39;00m i \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mset\u001b[39m(df[df[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mjob.dq\u001b[39m\u001b[38;5;124m'\u001b[39m]\u001b[38;5;241m.\u001b[39misin([\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m广州-天河区\u001b[39m\u001b[38;5;124m'\u001b[39m])][\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mcomp.compIndustry\u001b[39m\u001b[38;5;124m'\u001b[39m])\n\u001b[0;32m     11\u001b[0m         ]\n\u001b[0;32m     12\u001b[0m     }\n\u001b[0;32m     13\u001b[0m ]\n\u001b[0;32m     14\u001b[0m data\n",
      "Input \u001b[1;32mIn [31]\u001b[0m, in \u001b[0;36m<listcomp>\u001b[1;34m(.0)\u001b[0m\n\u001b[0;32m      1\u001b[0m data \u001b[38;5;241m=\u001b[39m [\n\u001b[0;32m      2\u001b[0m     {\n\u001b[0;32m      3\u001b[0m         \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mname\u001b[39m\u001b[38;5;124m\"\u001b[39m:\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124m广州-天河区\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m      4\u001b[0m         \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mchildren\u001b[39m\u001b[38;5;124m\"\u001b[39m:[\n\u001b[0;32m      5\u001b[0m             {\n\u001b[0;32m      6\u001b[0m             \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mname\u001b[39m\u001b[38;5;124m'\u001b[39m:i,\n\u001b[0;32m      7\u001b[0m             \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mchildren\u001b[39m\u001b[38;5;124m'\u001b[39m:[\n\u001b[1;32m----> 8\u001b[0m                 {\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mname\u001b[39m\u001b[38;5;124m'\u001b[39m:j} \u001b[38;5;28;01mfor\u001b[39;00m j \u001b[38;5;129;01min\u001b[39;00m \u001b[43m广州天河行业_岗位\u001b[49m[i]]\n\u001b[0;32m      9\u001b[0m             } \n\u001b[0;32m     10\u001b[0m             \u001b[38;5;28;01mfor\u001b[39;00m i \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mset\u001b[39m(df[df[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mjob.dq\u001b[39m\u001b[38;5;124m'\u001b[39m]\u001b[38;5;241m.\u001b[39misin([\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m广州-天河区\u001b[39m\u001b[38;5;124m'\u001b[39m])][\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mcomp.compIndustry\u001b[39m\u001b[38;5;124m'\u001b[39m])\n\u001b[0;32m     11\u001b[0m         ]\n\u001b[0;32m     12\u001b[0m     }\n\u001b[0;32m     13\u001b[0m ]\n\u001b[0;32m     14\u001b[0m data\n",
      "\u001b[1;31mNameError\u001b[0m: name '广州天河行业_岗位' is not defined"
     ]
    }
   ],
   "source": [
    "data = [\n",
    "    {\n",
    "        \"name\":\"广州-天河区\",\n",
    "        \"children\":[\n",
    "            {\n",
    "            'name':i,\n",
    "            'children':[\n",
    "                {'name':j} for j in 广州天河行业_岗位[i]]\n",
    "            } \n",
    "            for i in set(df[df['job.dq'].isin(['广州-天河区'])]['comp.compIndustry'])\n",
    "        ]\n",
    "    }\n",
    "]\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "308e2df6",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Tree\n",
    "\n",
    "\n",
    "data = [\n",
    "    {\n",
    "        \"children\": [\n",
    "            {\"name\": \"B\"},\n",
    "            {\n",
    "                \"children\": [{\"children\": [{\"name\": \"I\"}], \"name\": \"E\"}, {\"name\": \"F\"}],\n",
    "                \"name\": \"C\",\n",
    "            },\n",
    "            {\n",
    "                \"children\": [\n",
    "                    {\"children\": [{\"name\": \"J\"}, {\"name\": \"K\"}], \"name\": \"G\"},\n",
    "                    {\"name\": \"H\"},\n",
    "                ],\n",
    "                \"name\": \"D\",\n",
    "            },\n",
    "        ],\n",
    "        \"name\": \"A\",\n",
    "    }\n",
    "]\n",
    "c = (\n",
    "    Tree()\n",
    "    .add(\"\", data)\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"Tree-基本示例\"))\n",
    "    .render(\"tree_base.html\")\n",
    ")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
